Structure query language (SQL): Study guides, Class notes & Summaries

What are the parts of Microsoft self-service business intelligence solution? Microsoft has two parts for Self-Service BI Microsoft has two parts for Self-Service BI Excel BI Toolkit and Power BI Excel BI Toolkit It allows users to create an interactive report by importing data from different sources and model data according to report requirement. Power BI It is the online solution that enables you to share the interactive reports and queries that you have created using the Exc...

What Is a software that reads and writes data in a database? Database management system or DBMS What is a computer programming language for writing database queries? Query language What is a command for a database that typically inserts new data, retrieves data, updates data, or deletes data from a database Query What is a group of queries that must be either completed or rejected as a whole? A transaction What Interprets queries, creates a plan to modify the database...

Database management systems (DBMS) What is a database management system? - a program controlling the structure of a database and access to the data; creates, processes, and administers database What are some advantages of a DBMS? - -reduced data redundancy -improved data integrity -more program independence -increased user productivity -increased security What is DBMS used for? - to create tables and relationships in databases What do applications use DBMS for? - to read, inse...

1NF Defined primary key, no multi-valued attributes 2NF 1NF + no partial dependencies 3NF 2NF + no transitive dependencies DBMS (Database Management System) a product used for the storage and organization of data that typically has defined formats and structures What does DBMS contain? Hardware, software, data, procedures, and access language Schema Defines logical structure of related objects Catalog Collection of all schema in the database ...

DDL correct answers Data Defintion Language DML correct answers Data Manipulation language SQL/PSM correct answers Structured Query Language/ Persistent Stored Modules TCL correct answers Transaction Control Language DCL correct answers Data Control Language What is Data Defintion Language used for correct answers Used for creating Tables, relationships and Other Structures What is Data Manipulation Language used for correct answers Used for queries and data modification Wha...

Use an example of a workflow in your project. What are Selectors? Selectors are a feature that enables the identification of a specific User Interface element through its address and attributes. • These are stored as XML fragments. • Made up of nodes. Each node is made up of: • Tags • Correspond to a visual element on the screen • Nodes in the selector XML fragment • Attributes • Key value pair that help identify an element What are Full Selectors vs Partial ...

SQL is a domain-specific programming language designed for managing and communicating with data held in a relational database management system SQL is used for: -creating databases -adding, modifying and deleting database structures -inserting, deleting and modifying records in databases -querying databases Data Definition Language (DDL) used to create and modify the structure of the database example: CREATE ALTER or DROP Data Manipulation Language (DML) used to inse...

The _______ activity records the customer requests for products or services. - ANSWER sales order processing This type of language uses natural languages to allow humans to communicate more directly to a computer. - ANSWER Problem and constraint This logic structure involves repeating a sequence as long as a certain condition remains true. - ANSWER Loop Which among the following would not be described in the systems analysis report? - ANSWER The training requirements for users The us...

SQL is a domain-specific programming language designed for managing and communicating with data held in a relational database management system SQL is used for: -creating databases -adding, modifying and deleting database structures -inserting, deleting and modifying records in databases -querying databases Data Definition Language (DDL) used to create and modify the structure of the database example: CREATE ALTER or DROP Data Manipulation Language (DML) used to inse...

The _______ activity records the customer requests for products or services. - ANSWER sales order processing This type of language uses natural languages to allow humans to communicate more directly to a computer. - ANSWER Problem and constraint This logic structure involves repeating a sequence as long as a certain condition remains true. - ANSWER Loop Which among the following would not be described in the systems analysis report? - ANSWER The training requirements for users The us...